﻿CREATE PROCEDURE [dbo].[proc_MarketProjectItem_SumSpendingTotals]
(
	@MID INT
)

AS
BEGIN

SELECT SUM(SpendingTotals) FROM MarketProjectItem mpi JOIN ProT_ClassT3 pct3 ON mpi.T3=pct3.id
WHERE MID=@MID

	SET NOCOUNT ON;


END
